Hi, In what place of OAC are you trying to do that? Because the last day of a month is something "dynamic" (28, 29, 30 or 31), you can generally easily get it by combining a number of simpl…

@User_FWBDT , As a quick fix I would say you can just comment out the call to the logoff at the end of your script: the open session will timeout and be closed anyway. I didn't use the webservic…

In OAS 7.6, if you use the catalog manager as mentioned above or the webservice available to retrieve those information, keep in mind that security is enforced. You will only be able to retrieve info…

TL;DR: There is no API that is built to work between different environments. All the APIs only operate in a single environment. This doesn't prevent you from connecting to the 2 environments, re…

Hi, Your need is to concatenate text, and for that you need to use LISTAGG itself. You call it by using EVALUATE (or EVALUATE_AGGR). That's how it is done because there isn't a "natura…